View: Opening Balances Audit Detail

RotoID: PM0404
Table: PMOBDA
DLL: PMOBDA

Compositions: 0

Keys: 3

Title	Fields

	POSTSEQNO, LINENO
	POSTSEQNO, DETAILNUM
	SEQ, POSTSEQNO, DETAILNUM

Fields: 76

Field	Index	Type	Title	Attributes

POSTSEQNO	1	Long	Posting Sequence	E A K R
LINENO	2	Integer	Line Number	E A K R
SEQ	3	Long	Sequence	E A
DOCNUM	4	String*16	Document Number	E A C
OPENTYPE	5	Integer	Opening Type	E A
FMTCONTNO	6	String*16	Contract	E A
CONTRACT	7	String*16	Contract	E A
PROJECT	8	String*16	Project	E A
COSTREV	9	Integer	Actual Type	E A
CATEGORY	10	String*16	Category	E A
RESOURCE	11	String*24	Resource	E A
COSTTYPE	12	Integer	Cost Type	E A
DETAILNUM	13	Long	Detail Number	E A C
COMMENTS	14	String*250	Comments	E A
CUSTOMER	15	String*12	Customer	E A C
BILLCCY	16	String*3	Customer Currency	E A C
RATETYPE	17	String*2	Rate Type	E A
RATEOP	18	Integer	Rate Operation	E A C
RATEDATE	19	Date	Rate Date	E A
RATE	20	BCD*8.7	Rate	E A
RATESPREAD	21	BCD*8.7	Rate Spread	E A C
OQTY	22	BCD*10.5	Original Quantity	E A C
AQTY	23	BCD*10.5	Actual Quantity	E A
OARITEM	24	String*16	Original A/R Item Number	E A
OARUOM	25	String*10	Original A/R Unit of Measure	E A C
OUNITCOST	26	BCD*10.6	Original Unit Cost	E A C
OEXTCOSTSR	27	BCD*10.3	Original Extended Cost	E A C
OEXTCOSTHM	28	BCD*10.3	Original Extended Cost	E A C
AEXTCOSTSR	29	BCD*10.3	Actual Extended Cost	E A
AEXTCOSTHM	30	BCD*10.3	Actual Extended Cost	E A
OOHTYPE	31	Integer	Overhead Type	E A C
OOHRATE	32	BCD*10.6	Overhead Rate	E A C
OOHPER	33	BCD*5.5	Overhead Percentage	E A C
OOHSR	34	BCD*10.3	Original Overhead Estimate	E A C
OOHHM	35	BCD*10.3	Original Overhead Estimate	E A C
AOHSR	36	BCD*10.3	Actual Overhead	E A
AOHHM	37	BCD*10.3	Actual Overhead	E A
OLABORTYPE	38	Integer	Labor Type	E A C
OLABORRATE	39	BCD*10.6	Labor Rate	E A C
OLABORPER	40	BCD*5.5	Labor Percentage	E A C
OLABORSR	41	BCD*10.3	Original Labor Amount Estimate	E A C
OLABORHM	42	BCD*10.3	Original Labor Amount Estimate	E A C
ALABORSR	43	BCD*10.3	Actual Labor Amount	E A
ALABORHM	44	BCD*10.3	Actual Labor Amount	E A
OTOTCOSTSR	45	BCD*10.3	Original Total Cost	E A C
OTOTCOSTHM	46	BCD*10.3	Original Total Cost	E A C
ATOTCOSTSR	47	BCD*10.3	Actual Total Cost	E A C
ATOTCOSTHM	48	BCD*10.3	Actual Total Cost	E A C
OBILLTYPE	49	Integer	Billing Type	E A C
OBILLRATE	50	BCD*10.6	Original Billing Rate	E A C
OBILLSR	51	BCD*10.3	Original Total Revenue	E A C
OBILLHM	52	BCD*10.3	Original Total Revenue	E A C
ABILLSR	53	BCD*10.3	Actual Total Revenue	E A
ABILLHM	54	BCD*10.3	Actual Total Revenue	E A
RBILLSR	55	BCD*10.3	Remaining to be Billed	E A
OPROFITSR	56	BCD*10.3	Original Profit	E A C
OPROFITHM	57	BCD*10.3	Original Profit	E A C
APROFITSR	58	BCD*10.3	Actual Profit	E A C
APROFITHM	59	BCD*10.3	Actual Profit	E A C
TARRECTSSR	300	BCD*10.3	Total A/R Customer Receipts	E A
ARRECDATE	301	Date	Last A/R Receipt Posting Date	E A
TAPPAYMTS	302	BCD*10.3	Total A/P Vendor Payments	E A
APPAYDATE	303	Date	Last A/P Payment Posting Date	E A
COSTDATE	304	Date	Last Cost Posting Date	E A
BILLDATE	305	Date	Last Billings Posting Date	E A
REVRECDATE	306	Date	Last Rev. Recognition Posting Da	E A
REVESTDATE	307	Date	Last Revised Posting Date	E A
LSTBILLPER	308	BCD*5.5	Last Billings Percent Complete	E A
PODATE	309	Date	Last Purchase Order Date	E A
PORECDATE	310	Date	Last P/O Receipt Date	E A
PORETDATE	311	Date	Last P/O Return Date	E A
CONTSTYLE	500	Integer	Project Style	E A C
PROJTYPE	501	Integer	Project Type	E A C
REVREC	502	Integer	Accounting Method	E A C
INVTYPE	503	Integer	Invoice Type	E A C
REVERSED	504	Integer	Reversed	E A C

This page was generated on 2006-Sep-07